SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 机构数据
-- ----------------------------
BEGIN;

INSERT INTO `sys_org` VALUES (1300000000001, 0, '苏州总公司', '10001', '', '', '', 1, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_org` VALUES (1300000000101, 1300000000001, '昆山分公司', '10101', '', '', '', 1, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_org` VALUES (1300000000111, 1300000000101, '研发部门', '10111', '', '', '', 1, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_org` VALUES (1300000000112, 1300000000101, '生产部门', '10112', '', '', '', 2, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_org` VALUES (1300000000113, 1300000000101, '市场部门', '10113', '', '', '', 3, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_org` VALUES (1300000000114, 1300000000101, '财务部门', '10114', '', '', '', 4, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);

INSERT INTO `sys_org` VALUES (1300000000201, 1300000000001, '常熟分公司', '10201', '', '', '', 2, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_org` VALUES (1300000000211, 1300000000201, '研发部门', '10211', '', '', '', 1, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_org` VALUES (1300000000212, 1300000000201, '市场部门', '10212', '', '', '', 2, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_org` VALUES (1300000000213, 1300000000201, '测试部门', '10213', '', '', '', 3, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_org` VALUES (1300000000214, 1300000000201, '运维部门', '10214', '', '', '', 4, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);

COMMIT;

-- ----------------------------
-- 菜单数据
-- ----------------------------
BEGIN;

INSERT INTO `sys_menu` VALUES (1300000001101, 0, 0, '系统管理', 'System', '/system', '', 1101, '', 'ri:settings-3-line', '', '', '', '', '', '', 1, 0, 0, 0, 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_menu` VALUES (1300000001110, 1300000001101, 0, '用户管理', 'SystemUser', '/system/user/index', '', 1110, '', 'ri:admin-line', '', '', '', '', '', '', 1, 0, 0, 0, 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_menu` VALUES (1300000001111, 1300000001110, 3, '添加', '', '', '', 1111, '', 'ri:admin-line', '', '', '', '', 'permission:btn:add', '', 1, 0, 0, 0, 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_menu` VALUES (1300000001112, 1300000001110, 3, '修改', '', '', '', 1112, '', 'ri:admin-line', '', '', '', '', 'permission:btn:edit', '', 1, 0, 0, 0, 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_menu` VALUES (1300000001113, 1300000001110, 3, '删除', '', '', '', 1113, '', 'ri:admin-line', '', '', '', '', 'permission:btn:delete', '', 1, 0, 0, 0, 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_menu` VALUES (1300000001120, 1300000001101, 0, '角色管理', 'SystemRole', '/system/role/index', '', 1120, '', 'ri:admin-fill', '', '', '', '', '', '', 1, 0, 0, 0, 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_menu` VALUES (1300000001130, 1300000001101, 0, '菜单管理', 'SystemMenu', '/system/menu/index', '', 1130, '', 'ep:menu', '', '', '', '', '', '', 1, 0, 0, 0, 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_menu` VALUES (1300000001140, 1300000001101, 0, '部门管理', 'SystemOrg', '/system/org/index', '', 1140, '', 'ri:git-branch-line', '', '', '', '', '', '', 1, 0, 0, 0, 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_menu` VALUES (1300000001150, 1300000001101, 0, '数据字典', 'SystemDict', '/system/dict/index', '', 1150, '', 'ri:git-branch-line', '', '', '', '', '', '', 1, 0, 0, 0, 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);

COMMIT;

-- ----------------------------
-- 角色数据
-- ----------------------------
BEGIN;

INSERT INTO `sys_role` VALUES (1300000000001, '超级管理员', 'admin', 1, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_role` VALUES (1300000000002, '普通角色', 'common', 2, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);

COMMIT;

-- ----------------------------
-- 角色菜单数据
-- ----------------------------
BEGIN;

INSERT INTO `sys_role_menu` VALUES (1300000000001, 1300000000001, 1300000001101);
INSERT INTO `sys_role_menu` VALUES (1300000000002, 1300000000001, 1300000001110);
INSERT INTO `sys_role_menu` VALUES (1300000000003, 1300000000001, 1300000001111);
INSERT INTO `sys_role_menu` VALUES (1300000000004, 1300000000001, 1300000001112);
INSERT INTO `sys_role_menu` VALUES (1300000000005, 1300000000001, 1300000001113);
INSERT INTO `sys_role_menu` VALUES (1300000000006, 1300000000001, 1300000001120);
INSERT INTO `sys_role_menu` VALUES (1300000000007, 1300000000001, 1300000001130);
INSERT INTO `sys_role_menu` VALUES (1300000000008, 1300000000001, 1300000001140);

COMMIT;

-- ----------------------------
-- 用户数据
-- ----------------------------
BEGIN;

INSERT INTO `sys_user` VALUES (1300000000001, 'admin', 'c93ccd78b2076528346216b3b2f701e6', '系统管理员', '', '', '', 1, 1300000000001, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);
INSERT INTO `sys_user` VALUES (1300000000002, 'test', 'c93ccd78b2076528346216b3b2f701e6', '测试人员', '', '', '', 1, 1300000000001, '', 1, 0, 'admin', '2022-02-22 22:22:22', NULL, NULL);

COMMENT;

-- ----------------------------
-- 用户角色数据
-- ----------------------------
BEGIN;

INSERT INTO `sys_user_role` VALUES (1300000000001, 1300000000001, 1300000000001);
INSERT INTO `sys_user_role` VALUES (1300000000002, 1300000000002, 1300000000002);

COMMENT;


SET FOREIGN_KEY_CHECKS = 1;
